﻿<!--#include virtual="/Common/Config.asp" -->
<!--#include virtual="/Common/conn.asp" -->
<!--#include virtual="/Common/Function.asp" -->
<%
'****************************************************
' 取回酒店城市对应的区域
'****************************************************

Response.Expires = 0
Response.CacheControl = "no-cache"
Response.AddHeader "Pragma", "no-cache"

Response.ContentType="text/html" 

YP_ID = reform("YP_ID")

sql = "SELECT YPS_ID,YPS_Name FROM YellowPage_Type_Sub WHERE YP_ID=" &YP_ID& " ORDER BY YPS_Order ASC"
Set rsTemp = conn.execute(sql)


Do While Not rsTemp.eof
	return_name = return_name&rsTemp("YPS_ID")&","&rsTemp("YPS_Name")&"|"
	rsTemp.movenext
Loop

If Len(return_name)>1 Then	
	return_name = Left(return_name,Len(return_name)-1) '去掉前面的,
End If

Set rsTemp = Nothing

Conn_Close()

Response.Write return_name

%>